package org.jeecg.modules.rencai.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.rencai.bo.NameValueBO;
import org.jeecg.modules.rencai.entity.EduInfo;
import org.jeecg.modules.rencai.vo.FullInfoVO;
import org.jeecg.modules.rencai.vo.ProfessionVO;

import java.util.List;

/**
 * @Description: 学校详情
 * @Author: jeecg-boot
 * @Date: 2020-04-03
 * @Version: V1.0
 */
public interface EduInfoMapper extends BaseMapper<EduInfo> {
    List<String> queryDistinctProfession(@Param("type") String type,
                                         @Param("province") String province,
                                         @Param("city") String city,@Param("mainType") String mainType,@Param("twoyy") String twoyy, @Param("ninebw") String ninebw);

    List<FullInfoVO> queryFullInfoByProfession(
            @Param("type") String type,
            @Param("schoolNature") String schoolNature,
            @Param("professions") List<String> professions,@Param("mainType") String mainType);


    List<FullInfoVO> queryBackStageFullInfoByProfession(@Param("vo") ProfessionVO vo);

    List<String> queryCityList(@Param("type") String type,@Param("mainType") String mainType);

    List<NameValueBO> countByProfession(@Param("type") String type, @Param("professions") List<String> professions, @Param("twoyy") String twoyy, @Param("ninebw") String ninebw,@Param("mainType") String mainType);

    List<NameValueBO> countCityByProfession(@Param("province") String province, @Param("type") String type, @Param("professions") List<String> professions,@Param("mainType") String mainType);

    Integer countBySearch(@Param("type") String type, @Param("professions") List<String> professions, @Param("twoyy") String twoyy, @Param("ninebw") String ninebw,@Param("mainType") String mainType,@Param("province") String province);

}
